package com.hz.framework.MyInterFace;

/**
 * 公共Forward 查找页面的对象名称
 * */
public interface SystemInterFace {

	/* 空字符串 */
	public static final String EMPTY = "";

	/* 删除 ActionForward 转页参数 */
	public static final String DELFW = "delFW";

	/* 查询 ActionForward 转页参数 */
	public static final String SELFW = "selFW";

	/* 修改 ActionForward 转页参数 */
	public static final String UPDFW = "updFW";

	/* 插入 ActionForward 转页参数 */
	public static final String INSFW = "insFW";

	/* 下一页 ActionForward 转页参数 */
	public static final String NEXTFW = "nextFW";

	/* 上一页 ActionForward 转页参数 */
	public static final String PREFW = "preFW";
	
	/* request.setAttribute()方法 name 名 */
	public static final String LSTVALUE = "value";
	
	/* XML页面数据邦定 request.setAttribute()方法 name 名 */
	public static final String XMLVALUE = "xml";

	/* 判断删除页面控件按扭 name 名 */
	public static final String DEL = "删除";

	/* 判断录入页面控件按扭 name 名 */
	public static final String INS = "保存";

	/* 判断修改页面控件按扭 name 名 */
	public static final String UPD = "修改";

	/* 判断查询页面控件按扭 name 名 */
	public static final String SEL = "查询";

	/* 判断下一页页面控件按扭 name 名 */
	public static final String NEXT = "下一页";

	/* 判断上一页页面控件按扭 name 名 */
	public static final String PRE = "上一页";
	
	//数据库驱动mysql
	String mySqlDriver = "org.gjt.mm.mysql.Driver" ;
	
	//mssql Jtds驱动
	String mssqlDriver = "net.sourceforge.jtds.jdbc.Driver" ;
	
	//Oracle驱动
	String oracleDriver = "oracle.jdbc.driver.OracleDriver" ;
	
	//Oracle查表名
	String tableName_Oracle = "SELECT table_name FROM all_tables where owner=?" ;
	
	//Oracle查字段
	String columnName_Oracle = "SELECT column_name,data_type FROM all_tab_columns where table_name=? " ;
	
	//MsSql2000查库名
	String dataBaseName_MsSql2000 = "select name from sysdatabases order by name " ;
	
	//MsSql2000查表名
	String tableName_MsSql2000 = "select name from sysobjects where type='U' and category = 0  order by name" ;  
	
	//MsSql2000查字段
	String columnName_MsSql2000 = "SELECT c.name as ColumnName,bt.name as BaseTypeName from syscolumns c INNER JOIN systypes st on st.xusertype = c.xusertype INNER JOIN " +
								  "systypes bt on bt.xusertype = c.xtype INNER JOIN sysobjects o on o.id=c.id WHERE c.number = 0 and c.name IS NOT NULL and o.name=?  order by ColumnName" ;
	
	//MsSql2005查库名
	String dataBaseName_MsSql2005 = "select name from sys.sysdatabases order by name" ;
	
	//MsSql2005查表名
	String tableName_MsSql2005 =  "select name from sysobjects where type='U' and category = 0  order by name" ;
	
	//MsSql2005查字段
	String columnName_MsSql2005 = "SELECT c.name as ColumnName,bt.name as BaseTypeName from sys.syscolumns c INNER JOIN sys.systypes st on st.xusertype = c.xusertype INNER JOIN " +
								  "sys.systypes bt on bt.xusertype = c.xtype INNER JOIN sys.sysobjects o on o.id=c.id WHERE c.number = 0 and c.name IS NOT NULL and o.name=?  order by ColumnName" ;
	
	//MySql查库名
	String dataBaseName_MySql = "show databases" ;
	
	//MySql查表名
	String tableName_MySql = "show tables" ;
	
	//MySql查字段
	String columnName_MySql = "select column_name,data_type from information_schema.columns where table_name=?" ;
	
}
